Release 10.1A: OpenEdge Development:
Basic Database Tools

Quick Field report

Choose Reports Quick Field to display information for the structure of fields in one or all tables in the working database. For each field, the report lists the order number, name, data type, flags, and format.

The Data Type column lists the first four characters of the field’s data type. If the type is decimal, the report includes the number of stored decimals digits (for example, deci–2). If the field is an array, the report includes the extent (for example, char[10]). The report shows a decimal array field as deci–2[5]. The Flags column indicates whether the field is case sensitive, mandatory, an index component, or a view component. Figure 8–7 shows an example of a quick field report for the customer table in the SPORTS database.

Figure 8–7: Quick Field Report dialog box

The Quick Field Report dialog box contains the following fields:

Switch Tables

Returns you to the list of tables for the working database.

Change Field Order

Changes the sort order of the fields to either alphabetical by name or numeric by order.

Print

Lets you print the report or write it to a file.